
/****** Object:  StoredProcedure [dbo].[web_insert_user]    Script Date: 10/19/2013 09:22:25 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

--IF EXISTS (SELECT * FROM sys.objects WHERE type = 'P' AND name = 'web_insert_user')
DROP PROCEDURE web_insert_user
GO

-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[web_insert_user] 
	@n60_kodas_sm varchar(50),
	@n60_kodas_ks varchar(100),
	@n60_pav2 varchar(100),
	@n60_pareigos varchar(100),
	@n60_vardas varchar(50),
	@n60_pav varchar(100),
	@n60_e_mail varchar(50)
AS
BEGIN

	SET NOCOUNT ON

	INSERT INTO n60_asm (n60_kodas_sm,n60_kodas_ks,n60_pav2,n60_kodas_gs,n60_pareigos,n60_vardas,n60_pav,n60_e_mail,n60_poz_date) 
	VALUES
	(@n60_kodas_sm,@n60_kodas_ks,@n60_pav2,'WEB',@n60_pareigos,@n60_vardas,@n60_pav,@n60_e_mail,'0')
	
	

END

GO

